M
mojoJojo
I need to format a sheet but I cant find a way to the tabs
back to normal. I'm working on excel2000. Please help, thx
mojoJojo
back to normal. I'm working on excel2000. Please help, thx
mojoJojo
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Hi
It sounds like your sheet/book is protected. Try Tools / Protection /
Unprotect sheet.
It sounds like your sheet/book is protected. Try Tools / Protection /
Unprotect sheet.
G
Guest
Sorry, Tools is also greyed out
-----Original Message-----
Hi
It sounds like your sheet/book is protected. Try Tools / Protection /
Unprotect sheet.
--
Andy.
.
A
Andy B
OK
That sounds like there might be a macro somewhere that is restricting access
to the sheet. One way to find out is to go to Tools / Macro / Security and
set the security level to Medium. If you try to open the sheet now, does it
ask if you want to enable macros?
That sounds like there might be a macro somewhere that is restricting access
to the sheet. One way to find out is to go to Tools / Macro / Security and
set the security level to Medium. If you try to open the sheet now, does it
ask if you want to enable macros?
M
mojoJOjo
Tools is greyed out on a new excel sheet too.
-----Original Message-----
OK
That sounds like there might be a macro somewhere that is restricting access
to the sheet. One way to find out is to go to Tools / Macro / Security and
set the security level to Medium. If you try to open the sheet now, does it
ask if you want to enable macros?
--
Andy.
.
D
Dave Peterson
If the toolbar offends thee, cut it out.
Excel stores toolbar customization in a file called *.xlb (name and location
vary with versions of excel/windows).
But you can find it via:
close excel
windows start button|find/Search
look for *.xlb
Rename all the ones you find to *.xlbOLD.
Then reopen excel to see if that helped.
If it did, you can dump the *.xlbOLD files and rebuild any customizations at
your leisure.
If it didn't help, you have more detective work to do. (maybe a workbook that
opens when you start excel that has a macro that does mean things...)
You can use some techniques that Chip Pearson shares on his web site:
http://www.cpearson.com/excel/StartupErrors.htm
Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)
Then one by one, you'll add one back and restart excel to see if that caused the
problem.
Excel stores toolbar customization in a file called *.xlb (name and location
vary with versions of excel/windows).
But you can find it via:
close excel
windows start button|find/Search
look for *.xlb
Rename all the ones you find to *.xlbOLD.
Then reopen excel to see if that helped.
If it did, you can dump the *.xlbOLD files and rebuild any customizations at
your leisure.
If it didn't help, you have more detective work to do. (maybe a workbook that
opens when you start excel that has a macro that does mean things...)
You can use some techniques that Chip Pearson shares on his web site:
http://www.cpearson.com/excel/StartupErrors.htm
Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)
Then one by one, you'll add one back and restart excel to see if that caused the
problem.