WisdomandLaughter
New Member
- Joined
- May 28, 2008
- Messages
- 35
Good Day,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am attempting to disable the Insert Worksheets feature. I found the following code and was using it with workbook open. It works great, except it is disabling insert worksheet in EVERY excel file I open, not just the file that houses the code.<o></o>
<o></o>
Help please! <o></o>
<o></o>
<o></o>
<o>Thank you.</o>
<o></o>
I am attempting to disable the Insert Worksheets feature. I found the following code and was using it with workbook open. It works great, except it is disabling insert worksheet in EVERY excel file I open, not just the file that houses the code.<o></o>
<o></o>
Help please! <o></o>
<o></o>
Code:
Application.CommandBars("Worksheet Menu Bar").Controls("Insert").Controls("Worksheet").Enabled = False<o:p></o:p>
Application.CommandBars("Ply").FindControl(, 945).Enabled = False<o:p></o:p>
<o>Thank you.</o>