hi,
I have a workbook which contains multiple sheets. Sheet1 activates another sheet and then after activation a user form is loaded. At that point the sheet gets hidden and sheet1 is shown.
I have tried vbModeless and application.screenupdating = true (and false)
but they are not working...
Hi all,
I have a code which activates a specific sheet and after activation a user form pops up.
Problem is when the user form pops up it disables the activated sheet which is not required.
Please suggest me how to achieve this. The code is -
Private Sub cmdOk_Click()
On Error GoTo ERROR...
Hi all,
since there is no option to upload complete workbook, I am posting a code snippet which is giving problems -
Private Sub cmdOk_Click()
On Error GoTo ERROR
Dim o As Integer
Dim i As Integer, r As Integer, c As Integer
Dim j As Integer
Dim sname As String
Dim...
Hi All,
I am using 32-bit excel on a 64-bit Windows 7 PC.
I am trying to attach the workbook but after compressing its size is around 3 MB and max size allowed is 1 MB so I am not able to attach it.
Please tell me how I can attach the file.
I have a VBA project built with Office 2007 that works fine on Office 2007 and Office 2010. When I use the same project on Office 2013 it gives me errors like code is not compatible with the version or architecture. I tried reference checking, removal of XLSTART file, Add-ins or third party apps...
I can upload the workbook but it's tightly bounded with my project. Without project it can't be opened.
Application was built with office 2007. It works well in office 2010 but it's giving problem with office 2013 and 2016. I have checked for references and nothing is showing as missing.
I...
Hello everyone,
I want to upload complete project but due to restrictions I can't do that.
I well tell you which line of above code is giving what error -
Columns("B").ColumnWidth = 25
Error - unable to set column width proerty of range class.
Cells(1, 1).Interior.Color = RGB(255, 198, 198)...
This is the code which is giving error -
Private Sub cmdOk_Click()
On Error GoTo ERROR
Dim o As Integer
Dim i As Integer, r As Integer, c As Integer
Dim j As Integer
Dim sname As String
Dim sData As String
Dim sValue As String
Dim sNameAlise As String
Dim...
I have a VBA project built with Office 2007 that works fine on Office 2007 and Office 2010. When I use the same project on Office 2013 it gives me errors like code is not compatible with the version or architecture. I tried reference checking, removal of XLSTART file, Add-ins or third party apps...