Hi
Newbie question, I think
I have some macros in my workbook that are activated by lt;ctrlgt;lt;shiftgt;A,
lt;ctrlgt;lt;shiftgt;B, lt;ctrlgt;lt;shiftgt;C, etc. My prob is that they work on EVERY
sheet, but i'd like them to work only on certain designated sheets. Any
ideas how to go about this?
Merci
Giselle
Giselle, you could check for the sheet name like this,
Sub test()
If ActiveSheet.Name = quot;Sheet2quot; Then
'Your Code here
Else
Exit Sub
End If
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003
quot;Gisellequot; gt; wrote in message
...
gt; Hi
gt; Newbie question, I think
gt;
gt; I have some macros in my workbook that are activated by lt;ctrlgt;lt;shiftgt;A,
gt; lt;ctrlgt;lt;shiftgt;B, lt;ctrlgt;lt;shiftgt;C, etc. My prob is that they work on EVERY
gt; sheet, but i'd like them to work only on certain designated sheets. Any
gt; ideas how to go about this?
gt;
gt; Merci
gt; Giselle
gt;
gt;
- May 27 Tue 2008 20:43
Limiting macros to certain sheets
close
全站熱搜
留言列表
發表留言