SOLVED
Home

Spreadsheet with VBA coding opens blank

%3CLINGO-SUB%20id%3D%22lingo-sub-320449%22%20slang%3D%22en-US%22%3ESpreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320449%22%20slang%3D%22en-US%22%3E%3CP%3EDell%20Latitude%20laptop%20E5500%3C%2FP%3E%3CP%3EWindows%2010%20Professional%3C%2FP%3E%3CP%3EExcel%20Office%20XP%20Standard%20(2007%20Conversion)%3C%2FP%3E%3CP%3EMy%20spreadsheets%20have%20been%20opening%20fine%20until%20I%20added%20a%20%22ClearCommand%22%20control.%20Now%20when%20I%20attempt%20to%20open%20the%20spreadsheet%20it%20opens%20blank.%20I%20can%20go%20to%20%3CSTRONG%3EOpen%3C%2FSTRONG%3E%20within%20the%20blank%20sheet%20and%20it%20will%20open.%20My%20Dell%20660%20PC%20with%20Windows%2010%20Home%20opens%20fine.%20Both%20computers%20are%20using%20the%20same%20Excel%20software.%20I%20sure%20would%20appreciate%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320449%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-323513%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323513%22%20slang%3D%22en-US%22%3EYou're%20welcome!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321750%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321750%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20already%20adjusted%20the%20file%20associations%20in%20Default%20Apps%2C%20and%20the%20File%20Type%20in%20the%20spreadsheet.%20It%20worked%20perfectly%20for%20a%20couple%20of%20reboots%2C%20then%20quit.%20Thanks%20to%20your%20suggestion%2C%20I%20did%20the%20repair.%20It%20didn't%20work%20at%20first%2C%20so%20I%20went%20back%20into%20File%20Associations%20and%20found%20that%20the%20repair%20had%20duplicated%20some%20of%20the%20associations.%20I%20clicked%20on%20the%20duplicate%20files%2C%20and%20when%20I%20did%2C%20they%20turned%20into%20a%20single%20file.%20Now%20my%20spreadsheets%20are%20working%2C%20with%20and%20without%20macros.%20I%20did%20have%20to%20go%20into%20my%20spreadsheets%20and%20change%20a%20couple%20of%20File%20Types.%20Thanks%20again%20for%20helping.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321665%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321665%22%20slang%3D%22en-US%22%3EThat%20probably%20means%20your%20file%20associations%20somehow%20went%20haywire.%20Best%20is%20to%20open%20Office%20setup%20and%20let%20it%20do%20a%20Quick%20repair.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321656%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321656%22%20slang%3D%22en-US%22%3E%3CP%3EYes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321352%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321352%22%20slang%3D%22en-US%22%3EIf%20you%20use%20FIle%2C%20Open%20to%20open%20the%20file%20in%20question%2C%20does%20it%20open%20then%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321130%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321130%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20discovered%20this%20problem%20has%20nothing%20to%20do%20with%20macros%20or%20VBA%20coding.%20The%20laptop%20is%20my%20wife's.%20I%20have%20made%20a%20few%20spreadsheets%20for%20her.%20The%20last%20one%20was%20a%20year%20ago%20and%20it%20opens%20ok.%20Any%20spreadsheets%20made%20now%20open%20with%20a%20gray%20blank%20screen%2C%20with%20or%20without%20controls%20using%20macro%20or%20VBA.%20A%20screenshot%20is%20attached.%20I%20apologize%20for%20the%20confusion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321032%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321032%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20reply.%3C%2FP%3E%3CP%3EI%20recorded%20a%20macro%20and%20named%20it%20%22ClearContents%22.%20Then%20I%20created%20a%20button%20in%20Draw%2C%20and%20assigned%20the%20macro%20to%20it.%20This%20works%20fine%20on%20my%20PC%2C%20but%20opens%20with%20a%20blank%20gray%20screen%20on%20the%20laptop.%20I%20know%20I%20said%20VBA%20coding%2C%20it%20was%20a%20macro%20instead%2C%20to%20delete%20user%20input.%20Do%20you%20think%20it%20would%20make%20a%20difference%20if%20I%20create%20a%20button%20with%20VBA%20coding%20instead%3F%20I%20don't%20have%20access%20to%20the%20laptop%20at%20this%20time%20to%20send%20a%20screenshot.%20I%20will%20be%20glad%20to%20send%20any%20screenshots%20later%20today%20or%20tomorrow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320884%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20with%20VBA%20coding%20opens%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320884%22%20slang%3D%22en-US%22%3ECan%20you%20post%20a%20screen-shot%3F%20What%20type%20of%20control%20did%20you%20add%3F%3C%2FLINGO-BODY%3E
TheWeav
Occasional Contributor

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.

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.

 

If you use FIle, Open to open the file in question, does it open then?
Solution
That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.

I had already adjusted the file associations in Default Apps, and the File Type in the spreadsheet. It worked perfectly for a couple of reboots, then quit. Thanks to your suggestion, I did the repair. It didn't work at first, so I went back into File Associations and found that the repair had duplicated some of the associations. I clicked on the duplicate files, and when I did, they turned into a single file. Now my spreadsheets are working, with and without macros. I did have to go into my spreadsheets and change a couple of File Types. Thanks again for helping.

You're welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies