iisjman07

I've inherited a macbook which is capable of running snow leopard but has no operating system currently install (wiped for security purposes). I was planning on buying Snow Leopard off amazon but someone told me I will need leopard installed first, then I can upgrade to snow leopard. This to me seems stupid, but is it true?

I've created a macro that counters one I created to protect cells with a password, and it works. However, if the password is incorrect, I get a runtime error asking if I want to debug, how can I stop this appearing and just have a message box saying the password is incorrect?

[QUOTE]Sub Unlockn()

If Worksheets("Invoice").ProtectContents = False Then

MsgBox Prompt:="No password applied, cannot unlock.", Title:="Cannot Unlock"

End

End If

adminpass = InputBox("Enter the administrative password to unlock...", "Enter Password:", "")

If adminpass = "" Then

Exit Sub

End If

ActiveSheet.Range("B18:B37").Select

ActiveSheet.Unprotect (adminpass)

ActiveSheet.Range("E18:E37").Select

ActiveSheet.Unprotect (adminpass)

ActiveSheet.Range("F18:F37").Select

ActiveSheet.Unprotect (adminpass)

ActiveSheet.Range("J1:M49").Select

ActiveSheet.Unprotect (adminpass)

ActiveSheet.Range("A1").Select

MsgBox ("Unlocking Completed")

End Sub

[/QUOTE]

I'm making an invoice for part of my IT coursework, and I'm trying to make a 'Save' button which will save the invoice sheet to any directory. I've successfully done this with use of the following code:

Sub NewWorkBooks()

Dim wb As Workbook

Dim wb2 As Workbook

Dim ws As Worksheet

Dim MyDir As String

Dim MyFile As String

Set wb = ThisWorkbook

Set ws = Sheets("Invoice")

With Application

.ScreenUpdating = False

.DisplayAlerts = False

End With

Set wb2 = Workbooks.Add

ws.Copy Before:=wb2.Sheets(1)

For Each ws2 In wb2.Worksheets

If Not ws2.Name = ws.Name Then ws2.Delete

Next ws2

Myname = InputBox("Enter the directory where you want the invoice saved. Please ensure the directory exists before continuing. EG: C:\invoice123 will save the sheet to drive C: and call it 'invoice123'.", "Enter Number", "C:\Invoice#")

wb2.SaveAs Filename:=Myname & ".xls"

wb2.Close

With Application

.DisplayAlerts = True

.ScreenUpdating = True

End With

End Sub

However, if you press 'Cancel' to the messagebox, it presents you with an error message saying 'Runtime error 1004:

Method SaveAs of object_Workbook failed'. Is there any way to stop this message appearing?

How secure is digital signing; can it be 'frauded' by malware?

What difference does it make if RAM has low or high Mhz?

How do you tell if a motherboard has a good chipset?

Is a key 32bit, 64bit, or does it not matter?

When is the windows 7 release date scheduled for?

How do I do this? It's for my GCSE IT work.

I'm currently doing my GCSE IT shizzle about web pages. Right now I am making a feedback form for visitors and I don't know what to do next. I've made my form with all the tick boxes, radio buttons and text entry fields but after you click the Submit link I want a confirmation box to popup asking something like 'Please confirm the entered information is correct'. Anyone help?

Most of the stuff I found on the net is pretty irrelavent. Are scientologists pro abortion or anti abortion?

What do Jewish people think about abortion? Are they pro abortion or anti abortion?

Title says it all.... I have tried many ways but none of them work...

I know I have a dynamic IP address, thus meaning it changes. But does my hostname ever change?

Is there a video editing program for windows with a kind of iMovie feel too it, where you have a slider, and you just split and delete the bits you don't want. I dont care how much it is.

How can I exclude a folder from scanning in Kaspersky Internet Security 2008? I want to exclude C:\Program Files\Adobe\, because I have all the adobe software, so the folder is huge and take ages to scan...

I had AVG, but decided it was rubbish and tried to uninstall it.

It said that it uninstalled successfully (after several sessions of Not Responding). Something didn't seem right... anyway, I am currently trying to install Kaspersky Antivirus, but it scans for incompatible software before install. It keeps detecting AVG, even though I have removed it (using Your Uninstaller), scanned the registry for invalid keys and deleted its 'Grisoft' entry in program file and program data.

I know McAfee had a tool (which co-incidentaly was very useful) that just deleted everything, even if somethings wrong.

Does AVG have a removal tool?

I don't care about the price, but does it detect and remove spyware well?