Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row labels displayed as column labels | Excel Discussion (Misc queries) | |||
Removing the print area dost from the screen | Excel Discussion (Misc queries) | |||
How do I go about finding and removing labels in formulas? | Excel Discussion (Misc queries) | |||
Removing labels and names in formulas | Excel Discussion (Misc queries) | |||
Overriding Actions of Excel DropDown Menus and Poup Menus | Excel Programming |