Search results for query: *

Hi All I have a business user that wants to look at pivot tables (since it is organized) and we have a comments field to the right, where the user can input comments to a particular field. The pivot table (its formatted but displays all the raw data) can be refreshed/filtered very quickly but...

Hi All I have several tables that helps me try to capture the unique number of vendors that are active from the users table as shown below in the SQL script. However, ther is an exception where users may be associated with multiple vendors. I feel that my script captures all associated vendor...

Hi All I have several tables that helps me try to capture the unique number of vendors that are active from the users table as shown below in the SQL script. However, ther is an exception where users may be associated with multiple vendors. I feel that my script captures all associated vendor...

Hi All I have locked off my macros if the user goes to VB editor. Is there a way to prevent the user from seeing the macro names when they go to Tools -> Macros? Thanks for your help Gautam

Hi Thanks for your help. I put in this command but I cannot fill down with this command. Ideally I would like to fill-down or fill-right but I dont want to drag the cell to a neighboring cell since it removes the format of the cell. I hope this makes sense. I want to prevent the following...

Hi All Everytime a user of a customized template does a drag and drop, it takes away the format of the cell. Is there a way to disable the drag and drop for the user? Thanks Gautam

Hi Roel Thanks appreciate the help Gautam Here is a snippet of what i did that worked: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 1 Then ThisRow = Target.Row If Target.Value <> Range("B1").Value Then Range("b1").Value = Range("a1").Value...

Hi All Here is my attached code that doesnt seem to work Ideally I would like to do the folllowing: Basically B1 gets the data from the webserver if A1 and B1 are not alike, a message box pops up B1 is set to A1. However, I cant get A1 and B1 constantly being checked with eachother. please...

Hi I would like my MS Excel template to display announcements that I store on a web server. I have created two dummy cells (hidden from the user). If cell B1 has changed value, a message box pops up displaying that the announcement. Then A1 is set to B1. Ideally, I would like a macro that...

Hi Mike That worked great!!!! Thanks so much Gautam

Hi Mike That helped greatly. However, it didn't seem to protect the format during a cut and paste from Excel. Is there a way of detecting if it was cut (vs. copied) from Excel? Is there a way of repressing the user to "cut and paste" from excel as well? Thanks Gautam

Hi Skip That worked in a general situation for me. But I have one problem. My sheet currently has a header and item level part. The item level part only displays one row. The user inputs the number of item level rows that he/she needs. The template then creates rows in the...

Hi Skip I have locked the format so that they cannot change the fill/borders/colors but they can still copy and paste from another sheet which can change the format of the cells. I ideally wouldnt like the user to use the before save event since they will not be required to save the...

Hi All I would like the user to manually enter the data, use the drop down list box or externally reference the data but I do not want the user cutting and pasting since it would change hte format of the template (ie colors, borders etc). 1) Is there a way of allowing them to cut and paste...

Hi SkipVought The color of the cell does not change, when I copy and paste from another worksheet. I want to change the color of the cells when the user copies and pastes from another worksheet or if the external link has a different color for their cell. Thanks for your help. Gautam

Hi how do I change the color of cell (for example green) when the contents are either inputted through a copy and paste from another worksheet. Thanks for all your help!!! Gautam PS I am using this function, which does not seem to work :(: Private Sub Worksheet_Change(ByVal Target As Range)...

Hi All I am using a template in MS Excel as a secure tool. The security will be authenticated from the client side as opposed to the server side. I have the user fill their username and password in a userform. This username and password is sent to a URL which displays XML data. If an element...

Hi All I want to store some xml data in a web server. The xml data is formatted and created in MS excel. I want excel to send the data to a webserver. I have an issue with two things: what is the command to send data? and to log on the webserver, i have to login..is there anyway to...

Thanks for your help. That should do it :) Gautam

Hi Gerry The reason why I ask is I am deploying an XL template externally that uses these macros that uses the mentioned libraries. I wanted to be sure that all the users with different versions of XL (97 onwards) could use the same tool so that there would be any errors. Thanks for your...