Removing Column and Row labels and menus from screen
 

I've seen excel files with visual basic code that turned
off the column labels and Row labels, and hid the menu
bars in Excel. It makes the excel document look and feel
like a program...

Does anyone know how to do this? Any help is greatly
appreciated.

Rgds,
Dan Winterton

Removing Column and Row labels and menus from screen
 

for row and column headers, turn on the macro recorder and go to

Tools=Options=View and unselect Row & column headers,

--
Regards,
Tom Ogilvy


"Dan Winterton" wrote in message
...
I've seen excel files with visual basic code that turned
off the column labels and Row labels, and hid the menu
bars in Excel. It makes the excel document look and feel
like a program...

Does anyone know how to do this? Any help is greatly
appreciated.

Rgds,
Dan Winterton

Removing Column and Row labels and menus from screen
 

Removing the Tool bars and changing application settings is a little bit
dangerous. If you don't handle errors in a graceful way and you crash the
spreadsheet then depending on what you have done toolbars may not come back
and settings may not be restored. If you are not to sure how to handle errors
I would be very cautious using these functions...

"Dan Winterton" wrote:

I've seen excel files with visual basic code that turned
off the column labels and Row labels, and hid the menu
bars in Excel. It makes the excel document look and feel
like a program...

Does anyone know how to do this? Any help is greatly
appreciated.

Rgds,
Dan Winterton