Options Menu

stevie3602

Board Regular
Joined
Nov 6, 2004
Messages
105
Some time ago I was able to get a macro on here to make the options menu password protected. It worked but I decided not to use that macro.

Now the problem is that when I open any excel spreadsheet or even a blank one, it wont let me open the options menu and it tries to laod the origianl spreadsheet that is was written on.

I tried un-installing all of office and re-installing it, yet the same problem exists.

Excuse my language, but this is really pissing me off.

Anyone have any ideas ??????????????
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
Find the original code, and alter it so it unprotects the options menu. I think somehow its still "protected",
If youre removing/reinstalling Office again, when it's removed you can have a look for all of possible documents which Excel uses and remove them if suspicious (ie deleting the office directory after uninstall)
good luck!
 

stevie3602

Board Regular
Joined
Nov 6, 2004
Messages
105
If I log in as a different user, Excel works like normal, therefore I must assume that there is a user file that controls the way excel behaves for each user. Does anyone know what that file is called and where to find it because I can just copy it over from one user to the other.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,606
Messages
5,597,134
Members
414,128
Latest member
Jorglo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top