vanishing vba

[LisaGreen]

Hi, I'm using w11 & excel 2016 64 bit.

Anyone had problems writing vb code, saving it and when coming back to it isn't there please.

Lisa

[HansV]

Did you save the workbook as .xlsx instead of as .xlsm or .xlsb?

[LisaGreen]

Nope. Tried numerous times now.

Lisa.

[HansV]

Please try the following experiment:

- Create a workbook and save it as a macro-enabled workbook (.xlsm).
- Activate the Visual Basic Editor.
- Insert a module and create some code, for example

Code: Select all

Sub Test()
    Beep
End Sub

- You should still see the code in the module window.
- In addition, you can see the module in the Project Explorer pane on the left.
- Now save the workbook from the Visual Basic Editor (press Ctrl+S or click the Save button on the Standard toolbar or select File > Save).
- Does the module disappear? If not, does the code disappear from the module window?

[snb]

Is the directory where you save this file a 'trusted location' ? (Trust center wise)

[LisaGreen]

Ok, I'll bite.

How do I tell if a folder is special?

Lisa

[SpeakEasy]

File > Options > Trust Center > Trust Center Settings > Trusted Locations

[LisaGreen]

Hey Speakeasy,

Thanks for replying. Is this possible using VBA do you know??

[snb]

Luckily not, since in that case the Trust Center would be useless.

[LisaGreen]

Ahhhhh yes. I got this when I thought about it.
Lisa

[LisaGreen]

Still looking at this.

Lisa