Macro command control by date
 

Hi,

I am using macro command (button) to access next worksheet or workbook. It
is possible or not if I want set command can be access by date. e.g after
this date (10 May 2006) the command not working or access denied.

TQ
param

Macro command control by date
 

yes, why not?

if format('yyyy-mm-dd',date)='2005-6-5' then
...
end

is it your need?



"Param" wrote:

Hi,

I am using macro command (button) to access next worksheet or workbook. It
is possible or not if I want set command can be access by date. e.g after
this date (10 May 2006) the command not working or access denied.

TQ
param

Macro command control by date
 

Param
Understand that Excel is not intended to be a secure platform. There
are many ways that you can control what a user can and cannot do as a
function of some parameter such as date. etc. But there are also many ways
that any scheme you come up with can be broken. HTH Otto
"Param" wrote in message
...
Hi,

I am using macro command (button) to access next worksheet or workbook. It
is possible or not if I want set command can be access by date. e.g after
this date (10 May 2006) the command not working or access denied.

TQ
param