ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel problem (https://www.excelbanter.com/excel-worksheet-functions/76779-excel-problem.html)

kevinp

Excel problem
 
Unprotected file claims to be protected when changing format style

David McRitchie

Excel problem
 
What specifically do you do to make it fail.
How do know that the file is unprotected.
What do you see that specifically tells you that something is protected.


Under tools, Protect
do you "Unprotect"

Under tools, Share workbook
if the box "Allow changes by more than one user" you have protected workbook

Check properties for your Excel file to see if you have Read only
you can uncheck it there, or in a higher level directory

Under File, Save As (workbook protection)
options
properties
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"kevinp" wrote
Unprotected file claims to be protected when changing format style





All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com