workbook specific macro code

[Vicky9063]

Hi,
I have created a workbook that i have tried to stop people deleting tabs from by disabling the tab toolbar. This has worked, but if i open up a spreadsheet that is not part of the workbook it also disables the tab toolbar in that spreadsheet.

'Disables the PLY Sheet function in the toolbar
Application.CommandBars("ply").Enabled = False

How do i make the code only specific to the workbook that i have the macro saved in??
Thanks
vicky

 

[tmcfadden]

To my knowledge, you can't make toolbars specific to the workbook ( hence the Application. prefix ).

Normally you'd use a 'Protection' scheme to stop people from deleting things. If you protect the workbook, users won't be able to delete worksheets.

-Tim