Thread: Control Box assigned to multiple spreadsheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LUKEMUDGE LUKEMUDGE is offline
external usenet poster
  
Posts: 3
Default Control Box assigned to multiple spreadsheets
I have the VB script to change the background color of my cells working but I
would like it to change another cell in a different worksheet. Can anybody
help me out with how to program the reference?

Here is the VB script I'm using to change the colors at the moment

Range("C5").Interior.ColorIndex = -4138 - Range("C5").Interior.ColorIndex
Reply With QuoteReply With Quote