ExcelBanter - Call workbook function

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Call workbook function (https://www.excelbanter.com/excel-programming/327879-call-workbook-function.html)

Selina

Call workbook function

I am using Excel 2000.
I have created a command button on a worksheet. On clicking this button, I
want a procedure in ThisWorkbook to run. What is run with the following ?

Private Sub BtnRetrieve()

Bob Phillips[_6_]

Call workbook function

There is a bit missing.

--

HTH

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

"Selina" wrote in message
...
I am using Excel 2000.
I have created a command button on a worksheet. On clicking this button, I
want a procedure in ThisWorkbook to run. What is run with the following ?

Private Sub BtnRetrieve()

Tom Ogilvy

Call workbook function

See answer to your later posting.

Declare your procedure in ThisWorkbook as public
--
Regards,
Tom Ogilvy

"Selina" wrote in message
...
I am using Excel 2000.
I have created a command button on a worksheet. On clicking this button, I
want a procedure in ThisWorkbook to run. What is run with the following ?

Private Sub BtnRetrieve()

All times are GMT +1. The time now is 01:34 AM.