Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo
In Excel 2000, whether I create a new workbook or open an existing one, I can
no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo
Does this mean that the options are gone and you can't choose them or that the
options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in An
The options were there but inacessible. This solved it though. Thanks.
"Dave Peterson" wrote: Does this mean that the options are gone and you can't choose them or that the options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in An
This leads me to another question. If I have blocked out all of those
features using VBA, then this command overrides all of my VBA protection. Is there a way to block people from using this command? "Dave Peterson" wrote: Does this mean that the options are gone and you can't choose them or that the options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in An
You can try your best to block them from getting to the VBE, but I gotta believe
that anyone really interested will find a way around it. Heck, they may have macros in other workbooks that do this kind of thing. Then they can just open that other workbook and run those macros. But if you want to try, you could look at this book: http://www.amazon.com/dp/0321262506 Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA By Stephen Bullen, John Green, Rob Bovey If I recall correctly, it describes how to make a dictator application within excel that controls the environment exactly how you want. JG wrote: This leads me to another question. If I have blocked out all of those features using VBA, then this command overrides all of my VBA protection. Is there a way to block people from using this command? "Dave Peterson" wrote: Does this mean that the options are gone and you can't choose them or that the options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in An
Dave,
May I enlist your help once more? I ran into another problem. Now the "save as" is grayed out (meaning it's there, but i can't use it). Your previous fix isn't working. Any suggestions? Thanks! "Dave Peterson" wrote: You can try your best to block them from getting to the VBE, but I gotta believe that anyone really interested will find a way around it. Heck, they may have macros in other workbooks that do this kind of thing. Then they can just open that other workbook and run those macros. But if you want to try, you could look at this book: http://www.amazon.com/dp/0321262506 Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA By Stephen Bullen, John Green, Rob Bovey If I recall correctly, it describes how to make a dictator application within excel that controls the environment exactly how you want. JG wrote: This leads me to another question. If I have blocked out all of those features using VBA, then this command overrides all of my VBA protection. Is there a way to block people from using this command? "Dave Peterson" wrote: Does this mean that the options are gone and you can't choose them or that the options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in An
Maybe you can reset that toolbar manually:
Tools|customize|toolbars tab select worksheet menu bar and click reset But this should do the same thing as that line of code. JG wrote: Dave, May I enlist your help once more? I ran into another problem. Now the "save as" is grayed out (meaning it's there, but i can't use it). Your previous fix isn't working. Any suggestions? Thanks! "Dave Peterson" wrote: You can try your best to block them from getting to the VBE, but I gotta believe that anyone really interested will find a way around it. Heck, they may have macros in other workbooks that do this kind of thing. Then they can just open that other workbook and run those macros. But if you want to try, you could look at this book: http://www.amazon.com/dp/0321262506 Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA By Stephen Bullen, John Green, Rob Bovey If I recall correctly, it describes how to make a dictator application within excel that controls the environment exactly how you want. JG wrote: This leads me to another question. If I have blocked out all of those features using VBA, then this command overrides all of my VBA protection. Is there a way to block people from using this command? "Dave Peterson" wrote: Does this mean that the options are gone and you can't choose them or that the options are there, but they don't work. If the options are missing, you could reset the toolbars: Open excel. start a new workbook open the VBE (hit alt-f11) hit ctrl-g type this: application.CommandBars("worksheet menu bar").Reset And hit enter Then type this: application.CommandBars("ply").Reset and hit enter. The first resets all the options in the File|edit|view menu bar. The second resets all the options on the worksheet tab menu. If the options are still there, but don't work, try this technique, too. If that doesn't help, write back describing what you do and what excel does. JG wrote: In Excel 2000, whether I create a new workbook or open an existing one, I can no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook either by right-clicking on the sheet tab or using the edit menu. Protect Worksheet is Off. Protect Workbook is Off. Things to Note: 1. I had been testing another workbook which had those features disabled by using VBA code. However, using that workbook on other computers has not had the same effect. 2. I had also tried a demo on Done-EX the Excel Compiler. 3. Both items 1 & 2 have now been removed from my computer but the problem persists. 4. I have tried repairing and reinstalling Excel but this hasn't helped. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am unable to insert, move, copy a worksheet | Excel Discussion (Misc queries) | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Insert sheet, move to end, rename with cell data. | Excel Discussion (Misc queries) | |||
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT | Excel Worksheet Functions |