Forum Discussion
Spreadsheet with VBA coding opens blank
Dell Latitude laptop E5500
Windows 10 Professional
Excel Office XP Standard (2007 Conversion)
My spreadsheets have been opening fine until I added a "ClearCommand" control. Now when I attempt to open the spreadsheet it opens blank. I can go to Open within the blank sheet and it will open. My Dell 660 PC with Windows 10 Home opens fine. Both computers are using the same Excel software. I sure would appreciate any help.
- That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
8 Replies
- Can you post a screen-shot? What type of control did you add?
Thanks for the reply.
I recorded a macro and named it "ClearContents". Then I created a button in Draw, and assigned the macro to it. This works fine on my PC, but opens with a blank gray screen on the laptop. I know I said VBA coding, it was a macro instead, to delete user input. Do you think it would make a difference if I create a button with VBA coding instead? I don't have access to the laptop at this time to send a screenshot. I will be glad to send any screenshots later today or tomorrow.
I have discovered this problem has nothing to do with macros or VBA coding. The laptop is my wife's. I have made a few spreadsheets for her. The last one was a year ago and it opens ok. Any spreadsheets made now open with a gray blank screen, with or without controls using macro or VBA. A screenshot is attached. I apologize for the confusion.
