View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck H.[_3_] Chuck H.[_3_] is offline
external usenet poster
 
Posts: 13
Default Determining the cell position of an object

Help would be very appreciated, I am actually working on a worksheet where I
have a certain number of Toggle buttons on each row but on a unique column.
On column B, I have a numbering system reflecting a WBS (Work breakdown
structure number) and each time I click on a particular Toggle button of a
particular row number I would like the event to do the following:
Unhide let us say the next 3 rows and within these rows I would have a
document name, which I could click over and get the the document written in
word to open for Editing or viewing.
Now once the closing the word document, I may click the same Toggle button
to Hide those same unhidden rows.

Can anyone help me achieve such thing? I am new to VBA and unable to program
such event.

Thank you in advance for your comments and help!

Regards,