I've had some issues lately where upon emailing a file it loses some functionality, but only for me...
Prime example:
I have a file that was working for me, on 64b 2013, I sent it to other people with 32b 2010 and 32b 2013, and it works fine for them.
However it has at some point stopped working for me on both my 64b 2013 and 32b 2010 machines. Despite the exact same file still working for other people.
An example of the error is...
I can see in the locals window at the error point that sSheet = "Report" and ws.Name = "AdminOnly" -- however it errors on the line;
With the error message;
I have enabled both macros and activex controls completely. I tried a the office repair tool. I rolled back to a system restore from when it was working. I reinstalled office. I did a fresh install of windows with a clean office install. Problem persists.
At the rate I'm pulling my hair out I'm going to be bald by the end of the week.
What am I missing here? Why can my colleagues run the macros but I cannot?
Prime example:
I have a file that was working for me, on 64b 2013, I sent it to other people with 32b 2010 and 32b 2013, and it works fine for them.
However it has at some point stopped working for me on both my 64b 2013 and 32b 2010 machines. Despite the exact same file still working for other people.
An example of the error is...
Code:
Function SheetExists(sSheet) As Boolean
SheetExists = False
For Each ws In ActiveWorkbook.Worksheets
If sSheet = ws.Name Then
SheetExists = True
Exit Function
End If
Next ws
End Function
I can see in the locals window at the error point that sSheet = "Report" and ws.Name = "AdminOnly" -- however it errors on the line;
Code:
If sSheet = ws.Name Then
With the error message;
Code:
Run-time error '57121': Application-defined or object-defined error.
I have enabled both macros and activex controls completely. I tried a the office repair tool. I rolled back to a system restore from when it was working. I reinstalled office. I did a fresh install of windows with a clean office install. Problem persists.
At the rate I'm pulling my hair out I'm going to be bald by the end of the week.
What am I missing here? Why can my colleagues run the macros but I cannot?