Excel 2007 vba code on sheet disappears when placed on Windows 10

**Domputer** · 02-23-2024, 07:28 PM

Copied excel sheet workbook containing check boxes to another windows 10 machine and check box properties are lost/overwritten. Just remains as properties. done this multiple times.
The is some vba code behind it and no longer viewable in the vba sheet properties window.
Using Excel 2007 as the most compatible with this sheet on the Windows 10 environment.
Have repaired excel 2007 and rolled back the last windows 10 update.
I know windows 10 does not want to run vba code as risk of it being a virus.
If i retype the vba code it does not redisplay on save and reopen.
Any ideas.

Charity has a simple excel program written prior to 2010 for invoicing.
Contains check boxes on each line.
Excel sheet works on other windows 10 machines.

**6StringJazzer** · 02-23-2024, 07:46 PM

Welcome to the Forum Domputer!

Originally Posted by Domputer

I know windows 10 does not want to run vba code as risk of it being a virus.

This is nothing new in Windows 10. It's been like for quite a while, and it's in the Excel settings, not Windows setting.

Even if VBA is prevented from running, it is not wiped out of the file.

What versions of Excel are running on the original machine, and the machine you are copying to? How are you doing the copy? I am wondering if there is some corruption occurring when the file is received there.

Since it works on other machines, it is likely there is some problem with the target machine. May be difficult to diagnose without access to the machine.

**Domputer** · 03-07-2024, 07:22 AM

Thanks for the prompt response Jeff.
Excel 2007 is on both machines.
Agree with you 100% that the vba code is not removed but just restricted or hidden on the new Windows 10 machine.
I copied back the excel file from the problem machine back to the original machine and it works and the vba code is visible again.

There must be something on that particular Windows 10 version that is restricting vba code from executing.
As the excel settings for macros, activex, etc have been enabled.

**6StringJazzer** · 03-07-2024, 03:32 PM

I am pretty sure this is not at all related to the Windows OS. Even if macros are disabled, the user is allowed to access the VBA code. You just can't run it.

I do not know if any Excel or Windows setting that would disable access to the VBA code on one machine while allowing it on another machine for the same file. The file can have protections to lock the VBA project, but that is internal to the file and would apply on any machine.

Whatever it is, it's specific to that machine. I will come back if I have other ideas, but it sounds like you have already checked the things I would recommend.

**TMS** · 03-07-2024, 06:50 PM

Maybe you saved the code for the check boxes in your Personal.xlsb macro file?

**Domputer** · 03-07-2024, 08:35 PM

Thx 6StringJazzer, agree with all your comments.
Suspect it's the windows 10 updates installed. Don't want to have to reinstall Windows 10.

Thx TMS, there are no *.xlsb files on my machine. Therefore none to transfer to another machine.
The excel workbook is already saved as *.xlsm Excel Macro Enabled

**TMS** · 03-07-2024, 08:38 PM

Can you redact a copy of the file and upload it here?

**6StringJazzer** · 03-07-2024, 11:39 PM

Originally Posted by Domputer

there are no *.xlsb files on my machine.

PERSONAL.xlsb is a default file that is created in the XLSTART folder when Excel is installed. It is hidden by default and opened every time Excel is opened. Are you saying that you have deleted that file?

**PrizeGotti** · 03-08-2024, 10:29 AM

We're assuming when you moved it to the windows 10 machine, you disabled the macro security on the file by right clicking on the file in the folder, selecting properties and checking the "Unblock" option?