K
Kim from AZ
Each time I create a new Excel spreadsheet it is automatically protected.
How can I stop this from happening.
Thank for your help.
How can I stop this from happening.
Thank for your help.
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.
R
Ron de Bruin
Hi Kim
Do you mean Protected with a password or that all cells are locked
by default
Do you mean Protected with a password or that all cells are locked
by default
K
Kim from AZ
Ron, thank you for your reply. It is not password protected, just protected.
Each time I open ANY excel document I have to go into TOOLS and then
PROTECTION and unprotect the sheet.
It came on suddenly, and now this step is required with every excel document
I open. Even on the documents I create, and I do not add protection to the
documents.
I hope you can help.
Thank you,
Kim [email protected]
Each time I open ANY excel document I have to go into TOOLS and then
PROTECTION and unprotect the sheet.
It came on suddenly, and now this step is required with every excel document
I open. Even on the documents I create, and I do not add protection to the
documents.
I hope you can help.
Thank you,
Kim [email protected]
D
Dave Peterson
Every workbook????
If you start a new one, save it, close excel, reopen excel and reopen your
workbook, then the worksheet(s) will be protected???? (save the workbook with
the worksheet unprotected.)
If that happens, then try this:
Close excel
reopen excel in safe mode
windows start button|Run
excel /safe
file|open your workbook
Are those worksheets still protected?
If no, then maybe you have a "helpful" addin that's either protecting those
sheets when you close the file (or when you open them (safe mode stops all
macros from running).
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm
And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm
Essentially, you move all of the stuff out of XLStart and you turn off all the
addins under Toools|addins.
Then you start adding things back one at a time and testing each time to see if
the problem is fixed. When you add something back that causes the problem to
come back, you'll have to decide what to do with that addin.
(Make sure you keep track of all the stuff you turn off and move.)
If you start a new one, save it, close excel, reopen excel and reopen your
workbook, then the worksheet(s) will be protected???? (save the workbook with
the worksheet unprotected.)
If that happens, then try this:
Close excel
reopen excel in safe mode
windows start button|Run
excel /safe
file|open your workbook
Are those worksheets still protected?
If no, then maybe you have a "helpful" addin that's either protecting those
sheets when you close the file (or when you open them (safe mode stops all
macros from running).
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm
And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm
Essentially, you move all of the stuff out of XLStart and you turn off all the
addins under Toools|addins.
Then you start adding things back one at a time and testing each time to see if
the problem is fixed. When you add something back that causes the problem to
come back, you'll have to decide what to do with that addin.
(Make sure you keep track of all the stuff you turn off and move.)