Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
write macro col A date Col B gas col C dollars | New Users to Excel | |||
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE | Excel Worksheet Functions | |||
ability to embed a macro within a csv | Excel Discussion (Misc queries) | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) |