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: 1
Default Reffering code to command button on diffrent sheets


Hi

Got a little probleme here :)

I want my command button on "sheet1" to copy things from "sheet2" and
paste it again in "sheet1". Excel only wants to do this when i put the
code in "ThisWorkbook", because if i put the code in sheet1 it doesnt
seem to know sheet2. But when i put my code in "ThisWorkbook" the
command button looks for its code in sheet1, not in "thisWorkbook",
where i just put it.
How can i tell tho command button to look for its code in
"thisWorkbook" ?

hope You can help me out.

Greetings


--
BlonTMamba
------------------------------------------------------------------------
BlonTMamba's Profile: http://www.excelforum.com/member.php...o&userid=30774
View this thread: http://www.excelforum.com/showthread...hreadid=504411

 
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
command button code dummy Excel Discussion (Misc queries) 2 December 1st 09 02:57 PM
VBA code behind command button [email protected] Excel Worksheet Functions 1 March 22nd 06 08:13 PM
Command button and linking with other sheets in the workbooks Ken Vo Excel Discussion (Misc queries) 2 January 17th 06 09:30 PM
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
Create Command Button from Code Bruce B[_2_] Excel Programming 0 July 14th 03 02:01 PM


All times are GMT +1. The time now is 11:29 PM.

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"