LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Restrict area where I can use button with macro

Hi, everybody.

I'm trying to implement two macros associated with two respective buttons.
The first button ("Add Row") adds rows and copies the formulae and format
from the row immediately above.
The second one ("Delete Row") deletes the row the cursor is on.

However, I'd like to restrict the area where I can use these 2 buttons.
I want my worksheet to start with only one row (row 7, containing the
formulae and format) where I can use the button "Add Row" (the "Delete Row"
button shouldn't work with row 7).
Let's say the user adds 3 more rows (8, 9, 10). Then, the buttons should
work whenever I place the cursor on any of these new rows and hit the
buttons. They shouldn't work anywhere else.

Just to emphasize, row 7 cannot be deleted, for it contains the formulae and
format.

How can I accomplish that? Can anybody help me?

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restrict Command Button jk Excel Programming 4 October 9th 06 03:35 AM
Macro - Set Print Area for Changing Data Area ksp Excel Programming 5 May 15th 06 10:20 PM
Restrict Scroll Area anuradha Excel Discussion (Misc queries) 0 July 20th 05 07:37 AM
How to restrict scroll area CyberBuzzard Excel Programming 4 March 23rd 05 02:37 PM
Message box display or something in the status area after macro button is pressed? StargateFan[_3_] Excel Programming 5 May 16th 04 09:04 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"