Use a public variable like this
Public Flg as boolean
in the workbook open even set the variable to false
Flg=False
Hv a toggle button on the worksheet
which will set the Flg value to True and False alternatively when you
press the button. when
the flg is true, function will work else it will n
Try removing Application.Volatile
On Jun 27, 5:38 pm, crossy75 wrote:
> I have this bit of code in a spreadsheet - it is used with a formula
> to count the number of visible rows. This is useful in accounts where
> people hid things thus counting what you see isnt always what you get!
>
> 'Functi
