Insert New Row on Sheet Not in Focus
 

Is there a code that I can assign to a command button located in sheet
1 that inserts a new row in sheet 3-without activating sheet 3
(putting it in focus)??

Insert New Row on Sheet Not in Focus
 

Hi Bull:

worksheets("sheet 3").rows(insert row number here).insert
or
worksheets("sheet 3").range("C5").entirerow.insert

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Bull" wrote:

Is there a code that I can assign to a command button located in sheet
1 that inserts a new row in sheet 3-without activating sheet 3
(putting it in focus)??