Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Protected Sheet - Insert Picture File


Workbook Password Protect 2 Levels. I have managed to write simple but effective code that allows only one password to be enetered to open a SS & offers 3 levels of protection, limited permission to enter data, read-only & data completely hidden. This is excellent for my needs however I want the user who has limited rw to be able to insert a pic file which is their signature but because the sheet has protected cells it won't allow user to insert picture jpg file.

I have just thought of a creative solution tho. What if the picture file is already saved in the workbook and by using code to ask to insert pic file it copies from one location in SS to the appropriate cell in the worksheets?

The scenario is that I have fortnightly timesheets in 12 calendar months in 12 separate sheets. When staff member fills in timesheet I want them to insert signature for that f/night indicating thatthey have filled it in & it is correct but because of protection it won't allow me to.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Insert Picture From File Increases File Size More Than The Picture You Inserting
I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB

why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?

View Replies!   View Related
Insert A Picture In The Word File?
I had copied a macro from this forum [it was posted by either shg or NBVC], and I modified it to fit my needs. The macro creates a new word document and sends a series of cells from an excel worksheet column to this word file. Everything works fine, but now I need to insert a picture after row 14. I have inserted the code [colored red], but I am sure the syntax or something isn't right. That part doesn't work.

View Replies!   View Related
Coding File Path To Insert Picture
Explored a few posts on my topic, but didn't quite find what I needed.

I need to open the Insert Picture dialog with it pointed at C:My DocumentsTemp. (Users will be required to save their images files to this location only).

Attempted to run a macro to get the code, but the dialog box forces you to select a file. I only need to get some low skilled users to the folder and let them select the image to insert.

View Replies!   View Related
Put Chosen Picture In Comment & Retrieve Picture On Other Sheet
I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice

View Replies!   View Related
Insert Picture
I'm trying to insert a bmp file- small picture into an excel file (sheet 4) in vba.

how do I select the picture and copy it into the excel file.

View Replies!   View Related
Insert A Picture-2007
I record a macro in Excel 2007 to insert a picture from a file in the active sheet, but when I stop recording it and I went so see the code and there was no code!!!

I did the same in Excel 2003 and the code was like this:
ActiveSheet.Pictures.Insert("c:1.jpg").Select

View Replies!   View Related
Insert Picture From Folder
I am using the code below to insert and resize images in excel. I was wondering is it possible to set up this macro so that I can just provide the directory and then have it so that just a random image is inserted rather than specifying an jpg number. The reason i need this is because the numbers in the folder range from 00000 to upto 20000 however not every folder has the full range of images i.e. Z:SingaporeSingapore TurfSingapore Turf Club 2QEII Cup 2006QEII Cup 2006_VDMillenium Copthorne InternationalTVGI Race Name Text may just contain one image and that would be image number 03965.

The other thing I would like to do is to have the name of the las 2 subfolders inserted into the cell above the image so for the example below you would have:

Millenium Copthorne InternationalTVGI Race Name Text
Picture

Millenium Copthorne InternationalTVGI Race Name Logo
Picture

Sub TestInsertPictureInRange()
InsertPictureInRange "Z:SingaporeSingapore TurfSingapore Turf Club 2QEII Cup 2006QEII Cup 2006_VDMillenium Copthorne InternationalTVGI Race Name Text3965.jpg", _ .........................

View Replies!   View Related
Insert Picture In Merged Cells
I have multiple merged cells (all same size). But not all in the same place.

I'm looking for a macro that can insert a picture in a selected merged cells and also size it to the merged cells.

I want to be able to choose a different picture from a location, for examle to network map P:.

I looked around but couldn't fins a code for this.

View Replies!   View Related
Insert Picture Sub Fails In '07
The code below will enable you to browse for a picture and insert it at cell location O9. It works great in excel '03 but when sub is ran in '07 it places the picture at about cell D5 and not really even lined up perfectly with that cell. Does any one have any idea why this is happening and how to make the sub work correctly in '07?

View Replies!   View Related
Auto Insert And Resize Picture
I have a sheet where I would like to have a picture inserted in a particular cell range and auto resized into that range. What I'm looking for is, if I type the name of a picture (meathead4uu.jpg) in a cell (Say, B3) then the picture should appear in range D14 to E28.

View Replies!   View Related
Insert/format Picture From Folder
I am using the code below to insert and resize images in excel. I was wondering is it possible to set up this macro so that I can just provide the directory and then have it so that just a random image is inserted rather than specifying an jpg number. The reason i need this is because the numbers in the folder range from 00000 to upto 20000 however not every folder has the full range of images i.e. Z:SingaporeSingapore TurfSingapore Turf Club 2QEII Cup 2006QEII Cup 2006_VDMillenium Copthorne InternationalTVGI Race Name Text may just contain one image and that would be image number 03965.

The other thing I would like to do is to have the name of the las 2 subfolders inserted into the cell above the image so for the example below you would have:

Millenium Copthorne InternationalTVGI Race Name Text
Picture

Millenium Copthorne InternationalTVGI Race Name Logo
Picture

View Replies!   View Related
DAO Query On Password Protected File: Could Not Decrypt File
I have an existing application that uses DAO sql queries to populate a form. It has always worked fine. Earlier this week, I password protected the spreadsheet. Now my DAO query fails. I get a run-time error '3161'. Could not decrypt file.

' Const stExtens As String = "Excel 8.0;HDR=Yes;"
Const stExtens As String = "Excel 8.0;HDR=Yes;PWD=money16;"

Private Sub Execute_Query(SQL)
'Instantiate the DAO objects.
strDb = ThisWorkbook.FullName
Set DAO_ws = DBEngine.Workspaces(0)
' code fails on the line below
Set DAO_db = DAO_ws.OpenDatabase(strDb, False, True, stExtens)
Set DAO_rs = DAO_db.OpenRecordset(SQL, dbOpenForwardOnly)
End Sub

View Replies!   View Related
Insert Picture Code Not Working In 2007
I have used the following code behind a projects Command button for some time, and works well in Excel 2002/2003.
It's used to look for and insert a Picture file, located on the users PC, select cell C2, re-size it to fit inside a bordered cell area and then nudge it over, off the border line.

Sub Load_Image()
Dim oPict, PictObj
Dim sImgFileFormat As String
'Open file
GetPict:
oPict = Application.GetOpenFilename("All Pictures (*.tif; *.bmp; *.jpg; *.gif; *.jpeg; *.png; *.cpt; *.tiff),*.tif; *.bmp; *.jpg; *.gif; *.jpeg; *.png; *.cpt; *.tiff")
If oPict = False Then End
Range("C2").Select
Set PictObj = ActiveSheet.Pictures.Insert(oPict)
With PictObj
.ShapeRange.LockAspectRatio = msoFalse
.ShapeRange.Width = 712#
.ShapeRange.Height = 510#
End With
PictObj.Select
With PictObj
Selection.ShapeRange.IncrementLeft 1#
Selection.ShapeRange.IncrementTop 1#
End With
Range("A1").Select

End Sub

Unfortunately, Excel 2007 doesn't seem to identify the Cell reference "C2".
It modifies the Picture size OK but does not position the picture in the correct position.
I've tried re-recording it but 2007 misses most of actions.???
Despite my efforts looking on other forums, I don't seem to find a code that works on both version of Excel.

View Replies!   View Related
Insert Picture (cannot View The Object Properties.)
The error I am getting (highlighted in red) is that it cannot view the object properties. So the picture is put in, but it's emplacement cannot be set and the picture cannot be renamed (which must occur for other macros to see it).
Pages are not protected. The only self automated macro is on workbook open, and it only resizes to view the area depending on the persons resolution.
Microsoft Excel 2003

View Replies!   View Related
Browse To Insert Picture & Size It
I Have Inspection Reports To Do
And They Come In With One Big Text Srting
I Haveused Formuee To Seperate Them And A Macro To Put Them On Seperate Sheets.but...

I Want To Insert A Picture (for More Indepth Reports)
Rather Than Inserting A Picture Can I Do A Macro That When It Is Run It Opens Up A Browser, Similar To The One In Insert Picture And Then Insert A Picture After The Bottom Cell And Resize It So It Will Be The Same Every Time? But At The Bottom Of The Last Line Of Data.

View Replies!   View Related
Protected Worksheet Macro To Insert Rows?
I have a protected worksheet, which I have 2 macros, 1 to spell check and 1 to insert rows, they both unprotect the sheet and re protect it again once they have completed. The problem I am having is that when I protect the work sheet first time round I tick the box to allow users to insert rows, once the Macros run they disable this functionality. Is there anyway I can include this in my Macros or do I need to add a new button!

View Replies!   View Related
Insert Picture Macro Doesn't Work In 2007
I just upgraded to Excel 2007 and my macro from Excel 2003 for inserting a picture doesn't work correctly in 2007. I have a command button that states insert picture and when you click it, it will let you insert a picture into the cell and hide the command button. In 2007 it will let you insert the picture, but it isn't centered and expands into other cells and the command button is still visible. The picture appears to be the correct size it just doesn't center itself in the cell and the command button is still visible. Below is the

View Replies!   View Related
Insert Picture & Auto Size To Active Cell Dimmensions
What I am trying to do is to give the user the ability to insert a photo and have it autosize into a range of cells--so far I can only get it to work with a single cell and a predefined file. Can this be refined so that rng references a group of cells and pic somehow lets the user input a file name or pick its name and location?

Sub test()
On Error Resume Next
Set pic = ActiveSheet.Pictures.Insert("C:
ange.gif")
On Error Goto 0
If Not pic Is Nothing Then 'Found it!'
Set rng = ActiveCell
With pic
.Height = rng.Height
.Width = rng.Width
.Left = rng.Left
.Top = rng.Top
End With
End If
End Sub

View Replies!   View Related
Save Range To Picture/Graphic File
I found thru this board's search function the solution to my original or saving excel range into a graphic file. {url} ...

View Replies!   View Related
Password Protected Sheet :: How To Unprotect A Sheet?
Does anyone know if there is a way to unprotect a sheet. The person who created this spreadsheet no longer works for our company and although we can see the spreadsheet, the formulas are hidden so we can't figure out where the data is being pulled in from. Any ideas?

View Replies!   View Related
Browse For Picture File And Put Location In Cell
I am trying to code where when someone hits the command button it will popup with the browse form and they find the location of the file and it puts there choice in a cell. don't know if it matters but the location would always be a picture. Here is what I have but it shows -1 in the cell

HTML Dim strFilePath As Variant
strFilePath = Application.FileDialog(msoFileDialogFolderPicker).Show
shUserInformation.Range("D12").Value = strFilePath

View Replies!   View Related
Download And Save Picture From Url Into Local File
I have a program operating in excel 2007 that extracts a picture from a URL and puts it into a PPT slide. I now discover that PPT 2007 doesn't allow this.

So my intent now is to download the jpg into a local file and then import into the PPT.

This is from a couple of sites:
[url]
[url]

At the top of the code:

Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" _
(ByVal pCaller As Long, _
ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

in the excel cell if a URL picture needs to be inserted it starts with the prefix "picture=" then the http address.

This did not work.

So I then copied the code from the websites into a module (changing the destination file and URL to mine of course) and called the procedure and still nothing.

View Replies!   View Related
Macro To See If File Exists Or Password Protected
I have written a macro to select a range of cells one by one and open the excel files mentioned in them and execute a task. It works fine. But I want the system to see if the file exists in its folder or if the file is password protected (for opening). Either of the case the file should be skipped without a warning message and any attempt to open. I need a macro for that. Following is the way the cell contents are

I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-LEGGINGS-13246.xls
I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-PANTS-13247.xls
I:ORDERSS-S 10ALIYAMARKET ORDERSADDADD-LADIES-SHORTS-13244.xls
I:ORDERSS-S 10MICHELLEGAMESWORLDWIDE COMPANYWORLDWIDE COMPANY - GAMES - 10014.xls

And following is the VBA code I wrote. It it almost stops when reaching a non-existing file name

View Replies!   View Related
Save A File When Vba Project Is Protected
I have an Excel File and I have created some code. I locked the VBA Project where that code is contained..... However when I work with the excel executing the mentioned code and after that I try to save it with the information resulting, Excel shows me the following message: "YOU CAN NOT SAVE TO THIS FILE FORMAT WHEN THE VBA PROJECT IS PROTECTED. YOU MAY UNPROTECT THE VBA PROJECT BY CHOOSING THE PROPERTIES COMMAND ON THE VISUAL BASIC EDITOR’S TOOLS MENU, AND ENTERING THE PASSOWORD FOR THE ACTIVE PROJECT....."...

View Replies!   View Related
Copy Picture From Sheet One To Sheet Two
I want to copy one picture from sheet one to sheet two. I just know the location of this picture.


View Replies!   View Related
Picture In Userform From Sheet
is it possible to have an image control in a userform to reference a picture inserted on a worksheet?

i have a number of pictures i want to load depending on certain events that happen in my sheet. i would like to be able to have this on multiple computers, and i would prefer to not to have to copy over the workbook AND a picture folder. i would like this to be as self contained as possible.

View Replies!   View Related
Picture Hyperlink To Different Sheet
One picture where i have added " sheet hyperlink" to excist sheet.

But how i´m trying to do same issue with application what i have made with VB, but there is two big walls .

VB application should work right this
User create picture name it "test". The user make sheet hyperlink with VB application and in sametime born new sheet named "test". Now we have picture what include link to test sheet.

View Replies!   View Related
Link Cells From One File To Another And Insert A New Line On The File
when I link cells from one file to another and insert a new line on the file I am linking to. the file that is linking goes down as follows:

=Safety.xls!$A$5
=Safety.xls!$A$6

How do I get Cell A5, to link to Cell A5 even if I add a new line in the Safety.xls spreadsheet. Taking the $ away does not work I have tried that.

View Replies!   View Related
Move The Picture Top Of The Sheet
How can I code a Picture so it moves atop a excel sheet?
I dont like the behavior this code runs.
ActiveSheet.Shapes("Picture 1").Select
Selection.ShapeRange.IncrementLeft 0.75

View Replies!   View Related
If Sheet Protected Then...
What code would I use to test if the sheet is protected or not? In other words:

If Activesheet.Protection = True Then
MsgBox "You have no authority!!!"
Else
' Some code here
End If

View Replies!   View Related
AllowFiltering In Protected Sheet
I have a question relating to the use of autofilter in a protected sheet.

My code is working fine in setting the autofilter and locking down the sheet but a user then loses the ability to use the (Data - Filter - Show All) menu button.

Is there a way to have the worksheet protected, allow the use of the auto filters, and allow the use of the show all button?

Code below incase it is of relevence ...

View Replies!   View Related
Autofiltering A Protected Sheet
When I protect my sheet and have the option to allow the users to autofilter the sheet, how come it doesn't work? I want to allow people to autofilter the data in the worksheet but not modify the contents of the cell.

View Replies!   View Related
Use Dropbox When Sheet Is Protected
I have a dropbox located on a sheet which other information needs to remain protected.

How do we give access to users to the dropbox while the remainder of the sheet is protected?

View Replies!   View Related
Cant Use [alt] + Pg Up Or Pg Dn On Protected Sheet
is there a code to still allow me to move between sheet tabs by using [alt] pg up or [alt] pg dn on a protected sheet?


View Replies!   View Related
Searching A Protected Sheet
I have a workbook whose worksheets use protection (don't want my calculations stomped on).

When the Protection is on, the search function does not work. You call it up, write what you are looking for, it accepts it, and then when you tell it to search it ignores you.

When you turn the protection off, the search function works just fine.

HOWEVER....Other workbooks I have with protection on its sheets do not share this problem, just this one workbook. And the problem is on all sheets in this workbook. The problem is not on any of the sheets in the other workbooks. I can't see anything different between them, but then I may not know what to look at.

View Replies!   View Related
Protected Sheet Will Not Allow Macro To Run
I have protected several sheets in my workbook to protect the forumlas and data for being tempered with by the users.

When I try to run my macro, I get an error message stating:

Runtime '1004'
You can not use this command on a protected sheet

And the debug is pointing to this part of my code

View Replies!   View Related
Protected Sheet & Allow Use Of Autofilter
I've locked certain columns on my worksheet so that users cannot overtype target dates etc. I've password protected the worksheet.

The password protection means that for some reason the users can't use the autofilters that are on the header row.

Can someone help me solve this problem; I still need the locked cells and password protection on the sheet but the success of the sheet depends on users being able to filter for specific rows using the autofilter....

View Replies!   View Related
Find And Replace On Protected Sheet
Is it possible to run a find and replace macro on a protected sheet? I know you can't use the built in Find and Replace but was hoping that I could get around that by using a macro.

View Replies!   View Related
Radio Buttons In Protected Sheet
I have a pair of radio buttons on an Excel 2007 sheet. I want the buttons to be clickable, but have the sheet protected.

Both are defined as unlocked. The Group containing the two buttons is also defined as unlocked.
But when I protect the sheet, one of the two buttons gets the pop-up saying the cell is protected - the other button is fine. I've even tried unlocking the cells behind the buttons, but it still pops up.

View Replies!   View Related
Apply Macro To Protected Sheet
I am creating a series of macros for a workbook, and at the beginning of each macro I unprotect all sheets and at the end of each macro I protect the sheets once more. The issue I am having is that even with these macros in place, I continue to receive an Excel alert message saying:

"The cell or chart that you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password."

The macro will then run. Everything works as it should, but I do not want this error message to pop up. I have tried inserting

Application.DisplayAlerts = False

into the code, but it does not stop the message.

View Replies!   View Related
Date Changes Only When Data Changes On Protected Sheet
I have a protected sheet that contains information that sometimes is viewed and other times is modified.

In cell Y49 (locked cell) I need to show the date in which any of the unlocked cells (modifiable while the sheet is protected) was modified.

View Replies!   View Related
Hyperlink Not Working If Sheet Protected
I have a excel worksheet with hyperlink. If the sheet is protected I am unable to use the hyperlink even though I have unblocked the protected cells.

View Replies!   View Related
Protected Sheet And UnProtected Cells
Excel 2007 or 2003 Is there code to be able choose the formating of a cell when right clicked if the cell is Unprotected. But, the sheet is Protect and the Workbook is Protected. Without Unprotecting anything 1st.

The reason being is sometimes the user may need to change the type of font from Arial, or Gdt or Y14.5M.

View Replies!   View Related
Unable To Use Autofilter On A Protected Sheet
i am uable to use autolfilter when protecting sheet via vbacode even though i have checked the autofilter box to be able to use it whilst protected, why does it work when i manually do protection but does not work via vba?

View Replies!   View Related
Allow For Group/ungroup On Protected Sheet
I'm building a template for various users. I have protected the sheet with only certain cells available for input. The file is very large and there are some sections that can be group/ungrouped as the user desires.

however, once I protect the sheet, they can no longer click the - or + to expand and collapse. How can I enable group/ungroup on a protected sheet?


View Replies!   View Related
Use Spell Check On A Protected Sheet?
Is it possible to use spell check on a protected sheet?

View Replies!   View Related
Allow Formatting Of Font In Protected Sheet
I have a protected sheet. Under normal circumstances, once the sheet is protected, the facility to choose the font goes away. You can allow it by putting a check against 'Format Cells' in the protection dialogue. But then, the user can format all aspects of the cell.
What if I want the user to be able to format only the font (type and size) and nothing else in the cell or in a range of cells. Is there a procedure or VBA for that?

View Replies!   View Related
Changing A Protected Sheet From A Form
I would like to be able to add data to a protected sheet, only from a form without unprotecting the sheet first. Below is the code.

View Replies!   View Related
Exit Macro If Sheet Protected....!
I'd like my button-triggered macro to exit and quit IF the sheet it is on is protected when someone presses the button. Here's the idea:

IF the active sheet protected THEN
Display "Can't do this on protected sheet" (and exit macro after click OK)
Else
run the rest of the macro.

View Replies!   View Related
Allow Hyperlink Clicks On Protected Sheet
Does anyone know if/ how i might unlock hyperlinks on my protected spreadsheet without having to unlock the cells they are placed in?

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved