LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KristiB
 
Posts: n/a
Default Visual Basic code available for all open workbooks

I found the coding on the Pearson website for how to count cells based on the
color of the cell. WOW! That is just what I have been trying to figure out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time. I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?
 
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
Macro that will add data from multiple workbooks to the 1st open r jbsand1001 Excel Discussion (Misc queries) 0 April 23rd 05 07:52 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
Visual Basic Error Message Scubasocks Excel Discussion (Misc queries) 0 January 28th 05 03:29 PM
Visual Basic Code Remains in "memory" Paul Moles Excel Worksheet Functions 1 December 10th 04 10:29 PM
Excel does not display workbooks open PeiMei Setting up and Configuration of Excel 0 December 9th 04 04:13 PM


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