Office 365 on Protected sheet written in Excel 2010

SusaninHouston

Active Member
Joined
Jan 13, 2005
Messages
295
I'm running into an odd situation on a workbook originally written in Excel 2010. The workbook in question contains several sheets, all of which are password protected. A user running Office 365 for Business is using the workbook and running a macro that essentially does the following:

1 - Unlock several worksheets, each containing a combination of locked formula and unlocked input cells

2 - Change formulas in a range of cells (that includes both locked formula and unlocked input cells)

3 - Re-lock the worksheets

This VBA code was originally written several years ago and has worked reliably on several hundred PCs running multiple Excel versions. In fact, it also seems to work on this PC with this Excel version also, EXCEPT for this.

After running the macro, the formerly-unlocked input cells (ALL of them on the worksheet - NOT just the ones in the change area) now throw a protected-worksheet error as if the cells were locked by the macro.

And just to make it extra weird, clicking onto a different worksheet in the workbook, then back to the original unlocks the cells for input again...

Any ideas? I cannot control which version of Excel/Office my users use, but can ask them to install patches or updates.
 
Last edited:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,225,397
Messages
6,184,716
Members
453,254
Latest member
topeb

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
Back
Top