Recent content by sofiavba

Thanks Skip.

Can anyone tell me if it is possible to have two different types of formats on one cell? For example if I enter 100%, do a percent formula and if I enter 100 I do an integer value formula.

This unprotects the full worksheet, I need only one row on the different sheet to be updateable. Meaning, Sheet1 has the checkbox, when the checkbox is checked and the user goes to sheet2 only one row should be updateable, they should not be able to update any other row which was protected...

Yes the getMortgage function is an Add-In and Userform are in the same workbook. When the user opens up the workbook, the data which is stored in our database needs to be displayed. To get the data we use the getMortgage function but the user must login and thats how the Userform comes into the...

Yes the posted code is in the Userform module. Here is the code when the userform is called Public Function getMortgage(uwWorkbook As Excel.Workbook, bSilent As Boolean, pwdExcelProtection As String, Optional ByRef bHadErrors As Boolean) As Boolean Dim myObj As Object Dim blnResult As...

Here you go: Option Explicit Private strErrorMessage As String Private Const ERR_LOGIN_ACCESS_DENIED = "Access Denied! Please enter a valid username and password." Private Const ERR_LOGIN_EMPTY_USERNAME = "Username cannot be empty!" & vbCrLf & "Please enter a valid username and password."...

Mike thanks you for the help but I have a question, when I put the code into my spreadsheet, my login form will not display. It basically bypasses the full login process and goes directly to the database without even asking for the users information. Am I doing something incorrectly? Thanks so...

Heres the issue, I have a excel spreadsheet that has 5 sheets. On one of the sheets there is a checkbox, when the checkbox is checked, two different sheets need to do the same thing. Both sheets have locked cells, with different formatting. I need to unlock each cell and allow all users to...

If the users enters a value we do nothing actually, the design at this point is to allow the user full access to all fields and formulas can be distroyed if needed. But we do want to know if the formula was replaced by a user entering data.

Hi everyone, First off I just wanted to say that this is GREAT, I have gotten so much good advice that I cant thank everyone enough. Ok here is the problem, I have a cell on my spreadsheet, which if empty when the sheet is opened. I want the cell to change its color when a user goes in and...

Gerry thats correct. If a user downloads the file again it t will be a new file and so the cancel button should be disabled and the user must login to the excel spreadsheet again.

I want the cancel button to be disabled only the first time ever a users opens a file that he/she downloads from our website.

Hi, I have a excel spreadsheet that when opened asks a user to login. I want the Cancel button not to be enabled when the user opens the file for the first time but after that the cancel button should be disabled. Is that possible?

Hi everyone, Can someone help with this small issue, I need to change the cell color if a value is changed after the first value has been saved to the database. Thanks

Hi everyone, Could anyone tell me how to create a Save As dialog box to pop up when a user clicks on a custom made menu option in excel. I have menu option called Check In, when a user clicks it a popup should display like a save as option. The user then can choose to save the excel file in...