Why are the macros gone after a user saves the spreadsheet?

Bob S Published at Dev

13

Bob S

We have spreadsheets with macros stored on a server. These are stored as .xlsm.

A user had W7 reinstalled on his PC. Now if he accesses a spreadsheet from the server the macros are missing. When he saved the spreadsheet back no other user could access the macro.

Does anyone have an answer why this happened?

CharlieRB

There are two possible things going on here; 1) when the file is opened and 2) when the file is closed.

For security reasons, Excel disables all macros by default. The user needs to modify the Macro Security in the Trust Center (File > Options > Trust Center > Trust Center Settings button > Macro Settings) to be able to use and edit a macro-enabled sheet.
When saving, Excel will ask the user to save the sheet as Macro-Enabled with and extension of xlsm. If the user chooses not to do this, it will save the sheet as a standard sheet without the macros.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-27

Comments

0 comments

Login to comment

Related

Jenkins user is gone after macOS update

Why are the colors of text gone after changing tabsize?

saveWorkbook function saves without macros

Why the Label in the ViewController is gone after I set the translucent to the background?

why the picture gone after do the update data in PHP

Why dependend dropdownlist is gone after trying to use pattern in different field?

Why my input gone after input into a structure through a function?

Why would a spreadsheet cause Excel to stop responding every other minute? No macros, manual calculations

Why does Clojure lack user defined reader macros?

How to set where SpreadsheetApp saves spreadsheet?

Networking Gone After Update

Why view animation is not gone

Why Bitmap saves to PNG

Why my styles gone when set user button control content in WPF?

Why, after compiling an interface, "default" method modifier is gone from "javap -v"?

Why are my changes gone after a cancelled git commit and how do I recover them?

Why are all newlines gone after PowerShell's Get-Content, Regex, and Set-Content?

"User Interface" for macros in imagej

Ajax result gone after reload

Compiz gone after 12.04 updates

After git, folders and files gone

Buttons gone after added swiperefreshlayout

Data gone after changing route

Element gone after page refresh?

Data gone after refresh page

Ubuntu display gone after reboot

Since macros are gone, how can I easily add a new Guid?

InsertAdjacentHTML, element saves after refresh

Why is wlan0 gone?

TOP Ranking

Article

HotTag

Archive