DEAR SIR

PLS HELP ASSISTANCE IN THE FOLLOWING:

1. HOW TO LIMIT THE EXCEL SHEET TO 100 ROWS AND 20 COLUMNS??

SO THAT THE USERS DONE KEEP SCROLLING UNWANTED BLANK AREAS.

2. CUSTOMIZED MENU BAR DOES NOT WORK, IF THE FILE NAME IS CHANGED AS THE MACRO PATH CHANGES ON SAVING THE FILE AS A DIFFERENT NAME.

I'm sorry you hit a hurdle in your solution. Here's an easy way to do what you want:

Select your rows and go to the following menu: Format | Rows | Hide

Then, select your columns and go to: Format | Column | Hide

It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as this one. Here is a link to resources that will help you:

http://msdn.microsoft.com/understanding/excel

HTH,

John.