ElvisSteel
Board Regular
- Joined
- Mar 23, 2009
- Messages
- 122
In Excel 2003 I had a number of standard macros that diabled the standard toolbars when a workbook was opened/activated and then restored them when it was closed/deactivated.
Is there an equivalent capability in Excel 2007?
I have a worbook in which I have disabled the Save,SaveAs, Close functions, but I would like to tighten the security a little more, by disabling certain functions in the ribbon.
On the Developer tab it is possible to view/run macros, which means I have had to check the username at the start of those macros that I don't want others to have access to.
Ideally I would like to simply disable the whole developer tab, or at least the macro options therein.
Can anyone advise as to if/how this can be done in 2007
Thanks
Is there an equivalent capability in Excel 2007?
I have a worbook in which I have disabled the Save,SaveAs, Close functions, but I would like to tighten the security a little more, by disabling certain functions in the ribbon.
On the Developer tab it is possible to view/run macros, which means I have had to check the username at the start of those macros that I don't want others to have access to.
Ideally I would like to simply disable the whole developer tab, or at least the macro options therein.
Can anyone advise as to if/how this can be done in 2007
Thanks
