View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daz Daz is offline
external usenet poster
 
Posts: 7
Default Calling worksheet functions from within a module

hi all.

I'm wondering how I can call a 'public' worksheet function from within
a module, or even from a seperate worksheet.

Say I have a function in a worksheet that sets the background colour of
range of cells to clear, and I have a button on a seperate worksheet,
and on the buttons onClick event I want it to run that function.

Help appreciated.

Darragh