Search results for query: *

The IT shop here at my day job had to rebuild my entire system profile last week (Windows 2003) due to a power supply problem, and I've lost some critical functionality under Office 2003. My problem is that I can't set Forms protection on any of my Word documents. This is something that I have...

Hi! Can anyone shed some light on this? I am getting the following error: Run-time error '4198' Command Failed This is showing up at the bottom of a macro that opens a Word document, allows changes to be made, prints and deletes that document and then opens a form-field document which is...

I password protect everything built for general use around here; it keeps inquisitive fingers out of my formulas and confines entries to only those places where data should be entered. I'm now working on an Excel project which requires that a small range of cells be protected until all of the...

I have the following code that is not working: Sub Interest() Worksheets("Debt w_Interest").Visible = True Worksheets("Sheet1").Visible = False Worksheets("Debt No Interest").Visible = False Dim Msg, Title, Style, Response Msg = "Press ""END"" Key when done" Title = "TO CALCULATE WHEN...

There is something wrong with this code, but I can't seem to find it. Private Sub Workbook_Open() Dim Msg, Style, Title, Response Msg = "Is this an Interest bearing debt?" Style = vbYesNo + vbInformation + vbDefaultButton2 Title = "CHOOSE TYPE of DEBT - Interest/No Interest" Response =...

I have given up trying to work this one out for myself. There must be an answer to this somewhere in the Excel Help files, but many days of searching there (and here) have left me with nothing but a dull ache behind my eyes. Is it possible to launch a macro from a cell? One of my users...

I have written a macro to capture data from a Word-based form and transfer it to an Excel spreadsheet. I can capture the data and write it, no problem, but I need to write to a specific worksheet, depending on the data in one of the captured Word form-fields. I can't find a command combination...