Forum Discussion
Spreadsheet with VBA coding opens blank
- That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
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.
- If you use FIle, Open to open the file in question, does it open then?
Yes.
- That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.