Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by gvilbis
at 2024-07-15 02:40:29
Point:500 Replies:5 POST_ID:828977USER_ID:10
Topic:
Microsoft Excel Spreadsheet Software;;VB Script
i wrote a macro in excel and i would like that after 3 months it will not be able to run any more until i will put new pass, how do i do that?
thanks
gvilbis
thanks
gvilbis
Expert: duncanb7 replied at 2024-07-15 05:13:26
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Assisted Solution
Expert: itjockey replied at 2024-07-15 03:09:58
20 points EXCELLENT
ooppps sorry seen post after posting.
Assisted Solution
Expert: itjockey replied at 2024-07-15 03:09:13
20 points EXCELLENT
I don't write code but my logic says.
A Macro password protected as mention by Mr.Duncan
B Need a code line which match date with todays date i.e. =TODAY() if it is after prescribed date then Don't execute.
Drawback - any one can fool this by changing system date ;(
Thanks
A Macro password protected as mention by Mr.Duncan
B Need a code line which match date with todays date i.e. =TODAY() if it is after prescribed date then Don't execute.
Drawback - any one can fool this by changing system date ;(
Thanks
Accepted Solution
Expert: duncanb7 replied at 2024-07-15 02:47:07
440 points EXCELLENT
OR you can set expire date for the macro on VBA
the following code is reference only.
You can put it the "ThisWorkbook" in the workbook
When you open new workbook and press atl-F11, it will
show a few sheets such sheet1(Sheet1),Sheet2(Sheet2),Sheet3(Sheet3) and "ThisWorkbook".
The macra will run first in proiority in the "ThisWorkbook" when
the workbook opens
Hope undrestand your question completely.If not , please point it out.
Duncan
the following code is reference only.
You can put it the "ThisWorkbook" in the workbook
When you open new workbook and press atl-F11, it will
show a few sheets such sheet1(Sheet1),Sheet2(Sheet2),Sheet3(Sheet3) and "ThisWorkbook".
The macra will run first in proiority in the "ThisWorkbook" when
the workbook opens
Hope undrestand your question completely.If not , please point it out.
Duncan
Sub AutoOpen()ExpirationCodeEnd SubSub ExpirationCode()Dim ExpirationDate As DateExpirationDate = DateSerial(2014, 10, 11)If Now() >= ExpirationDate ThenMsgBox “Trial Period ended on ” & CStr(ExpirationDate) & “.”ThisWorkbook.Close savechanges:=FalseEnd IfEnd Sub 1:2:3:4:5:6:7:8:9:10:11:
Assisted Solution
Expert: duncanb7 replied at 2024-07-15 02:43:45
20 points EXCELLENT
Could you do it by putting password on macro ?
take a look at this about protect macro on Excel
http://www.excel-easy.com/vba/examples/protect-macro.html
Duncan
take a look at this about protect macro on Excel
http://www.excel-easy.com/vba/examples/protect-macro.html
Duncan
