Excel 2007 Automatically Turning on Design Mode When Saving and Exiting

jzirk

New Member
Joined
Dec 23, 2016
Messages
10
Ok,

I have a weekly revenue report that several managers must complete each week. It uses command buttons to guide them through it with userforms. Long story short, 2 managers are using Excel 2007 and it keeps turning on design mode when they save it and exit.

Some things I've done:
  • Saved it with design mode off (no other managers have had issues)
  • Set security settings to automatically enable all macros without warning
  • Checked compatibility issues (nothing related to macros showed up, but this was the first time I've looked here so not sure if it would show there)

The weird thing is all I have to do is open the workbook when they email it to me (everything works fine without any changes), save it, and email it back to them. It works fine after that...

I work remotely, so replicating the issue is proving difficult- and trying to talk them through it is painful. I was thinking about having a macro run when the report is opened to turn it off each time, but I've read that macros won't run at all in design mode (I have a welcome message that pops up when opening, but no one can tell me if that pops up when they have issues).

Has anyone else had issues with this? Any ideas on how to stop it?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,223,888
Messages
6,175,206
Members
452,618
Latest member
Tam84

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