And for Excel 97 the setting was "on" or "off".

No levels between.


Gord Dibben Excel MVP

On Mon, 21 Mar 2005 02:09:42 +0800, "JulieD"
wrote:

Hi

glad to hear that it worked - for ver 2000 the default setting was medium ,
for ver 2002 / 2003 the default setting is high - which means that the
macros simply do not run and you don't get the prompt to enable them

Cheers
JulieD

wrote in message
...
Thanks, that worked. What is the default setting for
security in Excel? Does it always prompt you for having
macros in them?



-----Original Message-----
Hi

well all you need to do is open the workbook - press ALT &
F11 to display
the VBE Window, on the left find the workbook name in bold
and under this
you'll see ThisWorkbook
if you can't see the workbook name in bold you'll need to
choose view /
project explorer from the menu
double click on ThisWorkbook and copy & paste exactly what
you have written
below, save and close the VBE window and the workbook and
open it again to
test

note, however, you'll have to have your security settings
(tools / macros /
security) set to medium (or less - not recommended) ...
and choose "enable
macros" if prompted.

let us know how you go.

Cheers
JulieD


"Phil...Bob" wrote in message
.. .
I made 13 cds for my nephews with about 700 song samples on
them. (I didn't think it would THAT involved!) So now I
have exported the CD track info to txt files and I am
putting them in excel and I will email that to him. (I
guess text isn't good enuf for me) I am putting links in
the "Group" column. At least for the ones I can find
online. (some are OOP) I just want to display a dialog box
stating there are links in this column, so I just need
this:(?)

Private Sub Workbook_Open()
MsgBox "Click on group name to see the CD cover label"
End Sub

thanks


.