Somehow I managed to get a spreadsheet messed up with a weird window thingie…see image. Question: How the frak do I get rid of it?
Heya Gryper,
It looks like a Visual Basic forms element. I spend all day in Excel at work, but unfortunately my current gig uses Excel for Mac, which doesn’t support visual basic in Office 2009. I’m betting you already tried the obvious stuff (clicking on the edge of the box, right clicking). Try the forms toolbar or menu, or the visual basic toolbar, or somewhere in the Data menu. Good luck, and I feel your pain…
Thanks for the suggestions…nothing has worked so far.
Can you open a new spreadsheet and copy over everything except that box?
Bwahahahaha…I expected someone to say that. Yeah I can do that, but I would like to know what I did to create it and how to get rid of it without all the copying.
Gryper,
Tried to recreate the problem here. The only way I could recreate the situation was by adding the vb textbox and then protecting the sheet. To undo:
Home \ Format \ Protection \ Unprotect Sheet
You then (assuming this was the problem) can delete. This is a slightly long shot, but the only one that makes sense to me without a whole lot of background.
Good luck.
Thanks I looked at that, doesn’t seem be protected as I only get the option to Protect. My Excel version is old too, 2000.
I tried to duplicate what you have based on the box appearing after one click but was unsuccessfull. I can’t see it being a visual textbox as you would’ve been prompted to put it in. I’m drawing a blank, sorry.
Did the box appeared suddenly in your worksheet without you having imported data?
I have no idea how I did it but got spaztic when using Control C or V or something. I’m just going to copy and paste into a new worksheet.