Removing Column and Row labels and menus from screen

  • Thread starter Thread starter Dan Winterton
  • Start date Start date
D

Dan Winterton

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
 
for row and column headers, turn on the macro recorder and go to

Tools=>Options=>View and unselect Row & column headers,
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top