Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am asking you Excel guys as the Word guys are not so clever.
I need this macro to run in a “protected Form” in Word. Can some add what’s needed to unprotect and protect the form when this macro has been run. Sub tick() ' ' tick Macro ' Macro recorded 29/06/2011 by ' Selection.Font.Size = 18 Selection.InsertSymbol Font:="Wingdings", CharacterNumber:=-3844, Unicode _ :=True End Sub Thanks Johnnyboy |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you design your forms in Excel to begin with (much better suited for
this task - IMO), then applying sheet protection is all that's necessary. If you unlock cells requiring input from those who would be filling out the form, then they could move from field to field via the 'Tab' or 'Arrow' keys. This would obviate the need to print the form to fill it out. You could also provide instruction to use 'SaveAs' and append their name to the filename, OR make the file an XLT so they can open a new (unsaved) workbook based on that XLT. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
Protect UserInterface VS Protect/Unprotect | Excel Programming | |||
protect and unprotect | Excel Programming | |||
protect and unprotect | Excel Programming | |||
Unprotect and protect.... | Excel Programming |