Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running VBA Modules in Excel 2000
Should be OK - what are your security settings (tools, macros, security in XL2000) - if these are set to High then no macros will run. Set to medium to prompt user to enable macros. Or use Digital signatures or run from trusted location. Hope this answers your query.- Miranda
- Post #2
- Forum: Microsoft: Office
-
Watremarking Excel
How about using word as an interim step? Then you can bring the Excel into Word - format it in Word and then save as PDF...? Or programmatically include the Word art each time a page break is encountered in Excel. Ideas only...but it's sure to be possible. Regards, Miranda- Miranda
- Post #5
- Forum: Microsoft: Office
-
Deploying Access Project for workstations without Access
Hi there, You can do this by getting hold of the Access Runtime software that you can freely distribute to users who don't have Access. Versions are available for both Access 97 and 2000 and come as a part of the Microsoft Office Developer's toolkit. Users can update and access databases but...- Miranda
- Post #2
- Forum: Microsoft: Office
-
Excel User Form VBA Code
Hi there - you're just over complicating it - you need to run each if individually. Hope this helps Regards, Miranda see below:- Private Sub CommandButton1_Click() Dim xxx As String xxx = TextBox1.Text If CheckBox1.Value = True Then ActiveCell.FormulaR1C1 = "1 " & xxx...- Miranda
- Post #2
- Forum: Microsoft: Office
