Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Correct coding entry of VBA macros in Excel worksheet

If your code uses a Selection range, then you will need to select it each
time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" wrote in message
...
Bob: Thanks, will give both options a try. Also if I want a range of

cells
to be RT [running total] active, will the macros do so anytime I open the
worksheet? Or must I select all the cells and do something else?
Gracias!
--
WJR


"Bob Phillips" wrote:

In the VBIDE window (Ctrl-G), just type the macro names and return, or
select them from the Excel app via Alt-F8, and select and run from the
list.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" wrote in message
...
It has been some years since I needed this application. On an Excel
spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros

which
will activate a "running total" in each cell. I have the code, but

not
sure
how to enter [type] in the Editor page.
--
WJR






Reply
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
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
excel contents cells on different worksheet like a comment Church Administrator Excel Discussion (Misc queries) 1 August 31st 05 08:48 PM
Are macros created in Excel 2003 compatible with Excel 5.0/95? Hakmui Excel Discussion (Misc queries) 1 August 31st 05 01:33 AM
How can I protect a worksheet yet allow editing in Excel 2000 jimar Excel Discussion (Misc queries) 1 August 26th 05 11:25 AM
allow macros in protected worksheet Marge Excel Worksheet Functions 1 May 25th 05 04:23 PM


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