Macro command control by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
yes, why not?

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

is it your need?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent User to unlock Sheet Tabs 2
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
How to use multiple command button to copy user form data to multiple worksheet 0
Linking sheets which must update the date first. 3
Bizarre Custom Views behavior 2
Macros Don't Show On Commands List and 'Normal.dot' 3
making NT user/login user appear in a cell 1
Activate a moacro subroutine from a userform command button 1

Back
Top