Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
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 mawingho
at 2024-07-10 10:06:22
Point:500 Replies:2 POST_ID:828949USER_ID:10
Topic:
Microsoft Excel Spreadsheet Software;VB Script;Microsoft Office Suite
In Excel, if I try to use VBA to update a cell in a protected worksheet, it will result in error.
How can I solve this problem?
Thanks.
How can I solve this problem?
Thanks.
Expert: duncanb7 replied at 2024-07-11 09:32:17
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Accepted Solution
Expert: duncanb7 replied at 2024-07-10 10:18:14
500 points GOOD
you can do Unprotect Sheet - run code - reprotect sheet
Sheets("Sheet1").Unprotect "passwordgoeshere"
'Do stuff
Sheets("Sheet1").Protect "passwordgoeshere"
Hope understand your question completely.If not, please point it out
If provide your VBA code with error issue, it will be faster to solve
the issue
Duncan
Sheets("Sheet1").Unprotect "passwordgoeshere"
'Do stuff
Sheets("Sheet1").Protect "passwordgoeshere"
Hope understand your question completely.If not, please point it out
If provide your VBA code with error issue, it will be faster to solve
the issue
Duncan
