Hello,
I have an xls with 2 macros buttons. Those buttons have proporty "Do not move or size with cell".
However when I am applying advanced filter, delete lines show all data-both buttons are going to the line that was on top before applying "show all data"
So I am looking for a way to put in the macros some lines that will send macros button on the top of the sheet again (for example row1, column4 and row1, column 6)
Thanks in advance.
Erkamu
Guys,
It can't be so difficult.
I am in a hurry. Please help me.
Erkamu
You need to use the "LEFT" and "TOP" properties of the command button.
These are in "number of pixels from the left / top".
For example :
Puts a command button in cell D1, with "standard" sized columns and rows.
Please Login or Register to view this content.
Please click the * below if this helps
Hi,
I tried what you are sugesting. Added those 2 lines in the macros but it ends up with Run-time error 424 Object required
You probably use Form Buttons instead of ActiveX Buttons.
Replace your form buttons with activex ones. And don't ever use form buttons ever again
If you actually DO use activex buttons, then make sure you refer to the correct button (CommandButton1 / CommandButton2 / CommandButton3 etc...)
Last edited by JasperD; 06-19-2013 at 08:04 AM.
Please click the * below if this helps
my advice would be the exact opposite-forms buttons are more stableOriginally Posted by JasperD
Replace your form buttons with activex ones. And don't ever use form buttons ever again
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks