Command buttons changing to pictures?

[wackywoo105]

I have a spreadsheet we use for appointments. It has worked fine for years. Recently it sometimes fails to open. On trying again Excel offers to open it in safe mode and then conducts repairs before allowing it to save. It has a few command buttons and depending on the user one of the buttons can be hidden or displayed.

It appears these button are being converted to pictures, so of course the code crashes as the referenced button is no longer there to hide or show.

Can anyone help with why this has recently started happening and how to fix it?

Below is the error log and some images:

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error149520_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\Rev\Google Drive\APPOINTMENTS.xlsm'</summary>
<removedFeatures>
<removedFeature>Removed Feature: Object from /xl/workbook.xml part (Workbook)</removedFeature>
</removedFeatures>
</recoveryLog>

 

[skillilea]

What version of excel are you using?

Can you change the controls to a shape instead of command buttons? ie. Insert/Shape/Sqare and then assign a macro to the shape.

Form controls and/or activeX controls on sheets is risky in my experience.

 

[wackywoo105]

Currently on Microsoft® Excel® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 64-bit

thanks. I will look into what you suggest. Is it possible to assign the code to the button pictures?

 

[skillilea]

Yep, you can assign a macro to the shape. Right click on the shape and you will see the option.