LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Run a macro when clicking a cell.

On 1 May, 00:35, Gord Dibben <gorddibbATshawDOTca wrote:
Did you see my post with the macro and the link to Ron de Bruin's site?

If so, have you gone to Ron's site for info?

Gord Dibben *MS Excel MVP



On Wed, 30 Apr 2008 09:57:02 -0700 (PDT), wrote:
I can't get either of these to work though.


When I double-click a cell I get the error "Compile error. *Sub or
function not defined".


Do I need to link this into my calendar in some way?


Thanks for your help.


K-Rod.- Hide quoted text -


- Show quoted text -


Hi,

Yes I visited the link and copied the code but get a runtime error.

Can anyone help out? I can send my workbook via email if someone
would be so kind as to have a look at it? As I mentioned, I know
nothing about VB and just want to get this calendar working.

Thanks,

K-Rod.


 
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
clicking all the way to another cell jcheko Excel Worksheet Functions 5 April 25th 08 09:04 PM
Run a macro after clicking into cell Esradekan Excel Worksheet Functions 6 March 27th 08 10:34 PM
Using Macro to sort without clicking on macro button dd Excel Discussion (Misc queries) 3 May 3rd 07 06:00 PM
Colour by clicking cell ronoee New Users to Excel 12 January 29th 07 12:07 AM
Run macro from clicking on a cell jrd269 Excel Discussion (Misc queries) 2 June 3rd 05 09:35 PM


All times are GMT +1. The time now is 08:39 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"