Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can not insert sheet???
Hello,
Im just looking for opinions here and suggestions. I have an older file here (6mos)that has some odd behaviour. When I right click on the sheets present, I do not have the option to insert a new worksheet. I can't figure out for the life of me why, as every other file that I have that is similar has this ability. There is an enormous amount of VBA coding within the workbook, so perhaps if anyone knows if it has been accidentally disabled they could let me know the code to do that and I can search for it. Otherwise its probably something simple. I can't figure it out though : ( Thank you for your time -S |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can not insert sheet???
Check to see if the workbook is protected
"S Davis" wrote: Hello, Im just looking for opinions here and suggestions. I have an older file here (6mos)that has some odd behaviour. When I right click on the sheets present, I do not have the option to insert a new worksheet. I can't figure out for the life of me why, as every other file that I have that is similar has this ability. There is an enormous amount of VBA coding within the workbook, so perhaps if anyone knows if it has been accidentally disabled they could let me know the code to do that and I can search for it. Otherwise its probably something simple. I can't figure it out though : ( Thank you for your time -S |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can not insert sheet???
On Mar 15, 11:07 am, Duke Carey
wrote: Check to see if the workbook is protected "S Davis" wrote: Hello, Im just looking for opinions here and suggestions. I have an older file here (6mos)that has some odd behaviour. When I right click on the sheets present, I do not have the option to insert a new worksheet. I can't figure out for the life of me why, as every other file that I have that is similar has this ability. There is an enormous amount of VBA coding within the workbook, so perhaps if anyone knows if it has been accidentally disabled they could let me know the code to do that and I can search for it. Otherwise its probably something simple. I can't figure it out though : ( Thank you for your time -S- Hide quoted text - - Show quoted text - Arrrrrrrrrrrrgggggggggggghhhhhhhhhhh... Let this be a lesson - don't rely on VBA code for your protection needs *sheepish* Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you please let me know how to insert calander in a xls sheet | Excel Worksheet Functions | |||
I can't insert a new column in a sheet | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
How do I insert formulas from one sheet to another? | New Users to Excel | |||
i want to insert a link to another sheet tab | Excel Worksheet Functions |