How to position a button correctly when a new row is inserted

**Aswathy** · 09-23-2008, 11:21 PM

Hi All,

I have written a macro that contains a button, the click of button is supposed to insert a row in the excel. But when the row is inserted, the button is not positioning it correctly and the newly inserted row is hidden behind the button.

The code used to insert the button is as follows:

Please Login or Register  to view this content.

Please help

Cheers,
Aswathy

**Leith Ross** · 09-24-2008, 03:19 AM

Hello Aswathy,

I changed your macro and moved the command button to the row that is blackened. This makes it more visible and keeps it from covering the data.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**Aswathy** · 09-24-2008, 03:43 AM

Hi,

Thanks a lot. Even I was trying the same thing. I have a problem now. The VBA code which I am using to associate the click to the button is throwing some error and closing the app. Not even able to detect which line is causing the problem.

Please Login or Register  to view this content.

This itself is failing.
Any guesses on why its happening.

Please help me.

Cheers
Aswathy

How to position a button correctly when a new row is inserted

LinkBack

Thread Tools

Rate This Thread

Display

How to position a button correctly when a new row is inserted

Thread Information

Users Browsing this Thread

Similar Threads

Fix button position

position cursor on command button when userform opened

VBA Sub Procedures

Row Command button location

Option Buttons, copying

Bookmarks

Bookmarks

Posting Permissions