ExcelBanter - Macro writing a Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro writing a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/71908-macro-writing-macro.html)

John Vickers

Macro writing a Macro

I want to create a macro that can write info to the "ThisWorkbook"
module. Anyone know how to do it?

John Vickers

--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512923

Bob Phillips

Macro writing a Macro

See Chip's page at http://www.cpearson.com/excel/vbe.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"John Vickers"
wrote in message
news:John.Vickers.23aiko_1140039607.9126@excelforu m-nospam.com...

I want to create a macro that can write info to the "ThisWorkbook"
module. Anyone know how to do it?

John Vickers

--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile:
http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512923

John Vickers

Macro writing a Macro

Ok, I got this to work, but when I run the macro, it shows the vb
editor. Is there a command to disable this so it will just run in the
background without showing what it changed?

John Vickers

--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512923

Bob Phillips

Macro writing a Macro

Don't think so, it needs to work on the window. You could use Sendkeys to
close it down after.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"John Vickers"
wrote in message
news:John.Vickers.23c0qm_1140109801.1115@excelforu m-nospam.com...

Ok, I got this to work, but when I run the macro, it shows the vb
editor. Is there a command to disable this so it will just run in the
background without showing what it changed?

John Vickers

--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile:
http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512923

All times are GMT +1. The time now is 03:34 PM.