I have recorded a macro that will hide a column, copy the sheet and then go back to the original sheet and unhide the column. The trouble is the macro is bloated by this line: ActiveSheet.Buttons.Add(1671, 95.25, 155.25, 27).Select.
The workbook is totally free of buttons and is still saved as an xlsx file.
I get the same result when file is saved as xlsm.
Sorry getting used to forum: See reply for new file.
Last edited by Morten RB; 08-02-2022 at 07:14 AM.
There is no macro in attached file.
Edit your post and paste a macro code or attached file with macro (xlsm).
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Sorry my bad, try this one. Same problem as above.
Last edited by Morten RB; 08-03-2022 at 06:29 AM.
You worksheet is covered in buttons, about a 1000 of them. I was wondering why it took ages to open.
Scroll over to the right and you'll see them all.
So where did they all come from? I certainly didn't create them.
Looking at the Macro, it looks like you created them while recording the macro. Not sure if you were hitting the wrong key by accident, but they were definitely created when you recorded the macro.
Thank you for finding that, I wouldn't have thought to look over there. I guess fresh eyes are the key.
No problem. It's nothing the delete button can't fix, just delete those lines out of your code and you should be good.
I just deleted all the buttons and rerecorded the macro and all is good, it was very frustrating at the time though....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks