Run-Time Error 1004

[whudson1980]

Hello All, and happy belated Thanksgiving,

I have a workbook with about 20 sheets, most of which are protected.

I have a Main sheet with a "Log In" command button, and based on what password you enter, you're given access to certain sheets.

With that said, it all runs perfectly. And I have a BeforeSave sub that runs protections and basically "logs you out."

I tried making a Sub Called SaveAndLogout which simply does a "ActiveWorkbook.Save" for the purpose of saving when I have the ribbon hidden. But it returns "Run-Time Error 1004: The cell or chart that you are trying to change is protected and therefore read-only."

Why would the save button in the ribbon work just fine, but the ActiveWorkbook.Save throw this error?

Any ideas? I really want to hide the ribbon, which also (unfortunately) hides the save icon.

 

[whudson1980]

Also, just for the record, I did search the forum first. I found a few articles here and online referencing the Run Time error, but it seems that none of scenarios fit mine. It just seems that the VBA code to save the sheet is also trying to modify cells. Not sure.

 

[Fluff]

How about adding the save icon to the QAT?

 

[whudson1980]

How about adding the save icon to the QAT?

Oddly, its there. But when you hide the ribbon, it also hides the QAT. I'm using Excel 2007.

 

[Fluff]

Not sure why you'd get the error, from activeworkbook.save but not from the save icon.
Another possible option (if available in 2007) press Ctrl F1 this will minimise the ribbon rather than hiding it.