toolbars
I want to create a worksheet that on open removes all the tool bars from
excel, and to have a clean look. I want to to use macro command for certain fonctionality such as print, save. |
hi,
without at lease 1 tool bar you are not going to run macros. best to do what i did. create a custom tool bar with the commands i use most then deactivate all other tool bars. -----Original Message----- I want to create a worksheet that on open removes all the tool bars from excel, and to have a clean look. I want to to use macro command for certain fonctionality such as print, save. . |
Hi,
If you remove all the toolbars, this will affect all workbooks, not just that one. You will need to use an auto_close routine to reset commandbars (toolbars) on closing otherwise you are in deep shookers. - mark -----Original Message----- I want to create a worksheet that on open removes all the tool bars from excel, and to have a clean look. I want to to use macro command for certain fonctionality such as print, save. . |
All times are GMT +1. The time now is 08:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com