Thread: Can you run a macro on a worksheet from a module in an XLA?
View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Trefor Trefor is offline
external usenet poster
  
Posts: 201
Default Can you run a macro on a worksheet from a module in an XLA?
Tom,

I must be doing something really basic wrong. In the Sheet of the XLS I have:

Public CCRFsheet As Variant
..
..
Function Set_CCRF_Names()
ReDim CCRFsheetName(1 To 19)
CCRFsheetName(1) = "1. Introduction & Help"
Reply With QuoteReply With Quote